package Team;

import java.util.HashMap;
import java.util.List;

import org.apache.ibatis.annotations.Param;

public interface TeamMapper {
	void insert(HashMap<String,Object> item);
	TeamItem selectByIdName(@Param("contest_reg_id") int contest_reg_id,@Param("team_name") String team_name);
	List<TeamItem> selectApplyTeam(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id);
	List<TeamItem> selectByIdReg(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id);
	TeamItem selectById(int team_id);
	HashMap<String,Object> selectById2(int team_id);
	void update(@Param("team_id") int team_id,@Param("track_id") int track_id);
	
	
	
	void delete(int team_id);
	List<TeamItem> selectByCon_reg(@Param("contest_reg_id") int contest_reg_id);
	List<HashMap<String,Object>> selectByCon_reg2(@Param("contest_reg_id") int contest_reg_id);
	List<TeamItem> selectByCon_reg3(@Param("contest_reg_id") int contest_reg_id);
	List<HashMap<String,Object>> selectByCon_reg4(@Param("contest_reg_id") int contest_reg_id);
	
	void updateFlag(int team_id);
	void updatePrize(TeamItem item);
	void updateContent(@Param("team_id") int team_id,@Param("team_content") String team_content);
	
	List<TeamItem> selectByFlag0(int contest_reg_id);
	
	List<HashMap<String,Object>> selectAllFlag0();
	List<TeamItem> selectByFlag1(int contest_reg_id);

}
